** Public PSID Data mnemonics for The Effects of Changes in Local Bank Health on Household Consumption
** by Daniel Cooper and Joe Peek, ReStat 2020
/* ////////////////////////////////////////////////////////////////////////// */

/* This file is not functional code, it is simply a list of mnemonics for constructing
the subset of the public PSID data needed for running the other do files  */

********************************************************************************
* unique
* ER30001*1000 + ER30002

* sex (individual)
* ER32000

* age (individual)
local age [68]ER30004 [69]ER30023 [70]ER30046 [71]ER30070 [72]ER30094 [73]ER30120 [74]ER30141 [75]ER30163 [76]ER30191 [77]ER30220 [78]ER30249 [79]ER30286 [80]ER30316 [81]ER30346 [82]ER30376 [83]ER30402 [84]ER30432 [85]ER30466 [86]ER30501 [87]ER30538 [88]ER30573 [89]ER30609 [90]ER30645 [91]ER30692 [92]ER30736 [93]ER30809 [94]ER33104 [95]ER33204 [96]ER33304 [97]ER33404 [99]ER33504 [01]ER33604 [03]ER33704 [05]ER33804 [07]ER33904 [09]ER34004 [11]ER34104 [13]ER34204 [15]ER34305 [17]ER34504

* age (household)
local ageh [68]V117 [69]V1008 [70]V1239 [71]V1942 [72]V2542 [73]V3095 [74]V3508 [75]V3921 [76]V4436 [77]V5350 [78]V5850 [79]V6462 [80]V7067 [81]V7658 [82]V8352 [83]V8961 [84]V10419 [85]V11606 [86]V13011 [87]V14114 [88]V15130 [89]V16631 [90]V18049 [91]V19349 [92]V20651 [93]V22406 [94]ER2007 [95]ER5006 [96]ER7006 [97]ER10009 [99]ER13010 [01]ER17013 [03]ER21017 [05]ER25017 [07]ER36017 [09]ER42017 [11]ER47317 [13]ER53017 [15]ER60017 [17]ER66017

local agew [68]V118 [69]V1011 [70]V1241 [71]V1944 [72]V2544 [73]V3097 [74]V3510 [75]V3923 [76]V4438 [77]V5352 [78]V5852 [79]V6464 [80]V7069 [81]V7660 [82]V8354 [83]V8963 [84]V10421 [85]V11608 [86]V13013 [87]V14116 [88]V15132 [89]V16633 [90]V18051 [91]V19351 [92]V20653 [93]V22408 [94]ER2009 [95]ER5008 [96]ER7008 [97]ER10011 [99]ER13012 [01]ER17015 [03]ER21019 [05]ER25019 [07]ER36019 [09]ER42019 [11]ER47319 [13]ER53019 [15]ER60019 [17]ER66019

* relationship to head 
local relhead [68]ER30003 [69]ER30022 [70]ER30045 [71]ER30069 [72]ER30093 [73]ER30119 [74]ER30140 [75]ER30162 [76]ER30190 [77]ER30219 [78]ER30248 [79]ER30285 [80]ER30315 [81]ER30345 [82]ER30375 [83]ER30401 [84]ER30431 [85]ER30465 [86]ER30500 [87]ER30537 [88]ER30572 [89]ER30608 [90]ER30644 [91]ER30691 [92]ER30735 [93]ER30808 [94]ER33103 [95]ER33203 [96]ER33303 [97]ER33403 [99]ER33503 [01]ER33603 [03]ER33703 [05]ER33803 [07]ER33903 [09]ER34003 [11]ER34103 [13]ER34203 [15]ER34303 [17]ER34503

* sequence number
local seqno [69]ER30021 [70]ER30044 [71]ER30068 [72]ER30092 [73]ER30118 [74]ER30139 [75]ER30161 [76]ER30189 [77]ER30218 [78]ER30247 [79]ER30284 [80]ER30314 [81]ER30344 [82]ER30374 [83]ER30400 [84]ER30430 [85]ER30464 [86]ER30499 [87]ER30536 [88]ER30571 [89]ER30607 [90]ER30643 [91]ER30690 [92]ER30734 [93]ER30807 [94]ER33102 [95]ER33202 [96]ER33302 [97]ER33402 [99]ER33502 [01]ER33602 [03]ER33702 [05]ER33802 [07]ER33902 [09]ER34002 [11]ER34102 [13]ER34202 [15]ER34302 [17]ER34502

* same head (from changehh)
local changehh [69]V791 [70]V1461 [71]V2165 [72]V2791 [73]V3217 [74]V3639 [75]V4114 [76]V4658 [77]V5578 [78]V6127 [79]V6724 [80]V7357 [81]V8009 [82]V8633 [83]V9319 [84]V10966 [85]V11906 [86]V13533 [87]V14580 [88]V16054 [89]V17451 [90]V18782 [91]V20082 [92]V21388 [93]V23245 [94]ER3917 [95]ER6787 [96]ER9033 [97]ER11812 [99]ER15890 [01]ER19951 [03]ER23388 [05]ER27352 [07]ER40527 [09]ER46504 [11]ER51865 [13]ER57618 [15]ER64769 [17]ER70841

* new wife (from changewf)
local changewf [73]V3215 [74]V3637 [75]V4107 [76]V4694 [77]V5566 [78]V6115 [79]V6712 [80]V7345 [81]V7997 [82]V8621 [83]V9307 [84]V10954 [86]V13484 [87]V14531 [88]V16005 [89]V17402 [90]V18733 [91]V20033 [92]V21339 [93]V23196 [94]ER3863 [95]ER6733 [96]ER8979 [97]ER11731 [99]ER15805 [01]ER19866 [03]ER23303 [05]ER27263 [07]ER40438 [09]ER46410 [11]ER51771 [13]ER57508 [15]ER64630 [17]ER70703

* household id
local famid  [68]ER30001 [69]ER30020 [70]ER30043 [71]ER30067 [72]ER30091 [73]ER30117 [74]ER30138 [75]ER30160 [76]ER30188 [77]ER30217 [78]ER30246 [79]ER30283 [80]ER30313 [81]ER30343 [82]ER30373 [83]ER30399 [84]ER30429 [85]ER30463 [86]ER30498 [87]ER30535 [88]ER30570 [89]ER30606 [90]ER30642 [91]ER30689 [92]ER30733 [93]ER30806 [94]ER33101 [95]ER33201 [96]ER33301 [97]ER33401 [99]ER33501 [01]ER33601 [03]ER33701 [05]ER33801 [07]ER33901 [09]ER34001 [11]ER34101 [13]ER34201 [15]ER34301 [17]ER34501

* Education - see psid_educ_data_cleaning.do 

* labor income
local hlabinc [68]V74 [69]V514 [70]V1196 [71]V1897 [72]V2498 [73]V3051 [74]V3463 [75]V3863 [76]V5031 [77]V5627 [78]V6174 [79]V6767 [80]V7413 [81]V8066 [82]V8690 [83]V9376 [84]V11023 [85]V12372 [86]V13624 [87]V14671 [88]V16145 [89]V17534 [90]V18878 [91]V20178 [92]V21484 [93]V23323 [94]ER4140 [95]ER6980 [96]ER9231 [97]ER12080 [99]ER16463 [01]ER20443 [03]ER24116 [05]ER27931 [07]ER40921 [09]ER46829 [11]ER52237 [13]ER58038 [15]ER65216 [17]ER71293
local wlabinc [93]V21807 [94]ER4144 [95]ER6984 [96]ER9235 [97]ER12082 [99]ER16465 [01]ER20447 [03]ER24135 [05]ER27943 [07]ER40933 [09]ER46841 [11]ER52249 [13]ER58050 [15]ER65244 [17]ER71321

/* labincr = (hlabinc + wlabinc)/def

adjust the timing -- 1998 income pulled forward into 1999 etc
<h/w/>labincr_adj      = <h/w/>labincr[_n-1]  if <h/w/>labincr  ==. & year >=1997
<h/w/>labincr_adj      = <h/w/>labincr  if year <1997
<h/w/>labinc_adj      = <h/w/>labinc[_n-1]  if <h/w/>labinc  ==. & year >=1997
<h/w/>labinc_adj      = <h/w/>labinc  if year <1997    */

* interview month
local intmo [68]V99 [69]V553 [70]V1236 [71]V1939 [72]V2539 [73]V3092 [74]V3505 [75]V3918 [76]V4433 [77]V5347 [78]V5847 [79]V6459 [80]V7064 [81]V7655 [82]V8349 [83]V8958 [84]V10416 [85]V11600 [86]V13008 [87]V14111 [88]V15127 [89]V16628 [90]V18046 [91]V19346 [92]V20648 [93]V22403 [94]ER2005 [95]ER5004 [96]ER7004 [97]ER10005 [99]ER13006 [01]ER17009 [03]ER21012 [05]ER25012 [07]ER36012 [09]ER42012 [11]ER47312 [13]ER53012 [15]ER60012 [17]ER66012

* employment status
* <h/w>empstat = <h/w>empstat2 if year < 1994
local hempstat [94]ER2069 [95]ER5068 [96]ER7164 [97]ER10081 [99]ER13205 [01]ER17216 [03]ER21123 [05]ER25104 [07]ER36109 [09]ER42140 [11]ER47448 [13]ER53148 [15]ER60163 [17]ER66164
local hempstat2 [76]V4458 [77]V5373 [78]V5872 [79]V6492 [80]V7095 [81]V7706 [82]V8374 [83]V9005 [84]V10453 [85]V11637 [86]V13046 [87]V14146 [88]V15154 [89]V16655 [90]V18093 [91]V19393 [92]V20693 [93]V22448 [94]ER2068 [95]ER5067 [96]ER7163

local wempstat [94]ER2563 [95]ER5562 [96]ER7658 [97]ER10563 [99]ER13717 [01]ER17786 [03]ER21373 [05]ER25362 [07]ER36367 [09]ER42392 [11]ER47705 [13]ER53411 [15]ER60426 [17]ER66439
local wempstat2 [76]V4841 [79]V6591 [80]V7193 [81]V7879 [82]V8538 [83]V9188 [84]V10671 [85]V12000 [86]V13225 [87]V14321 [88]V15456 [89]V16974 [90]V18395 [91]V19695 [92]V20995 [93]V22801 [94]ER2562 [95]ER5561 [96]ER7657 

* business income
local hbusinc [93]V21810 [94]ER4120 [95]ER6960 [96]ER9211 [97]ER12194 [99]ER16491 [01]ER20423 [03]ER24110 [05]ER27911 [07]ER40901 [09]ER46809 [11]ER52217 [13]ER58018 [15]ER65198 [17]ER71275
local wbusinc [93]V21814 [94]ER4142 [95]ER6982 [96]ER9233 [97]ER12215 [99]ER16512 [01]ER20445 [03]ER24112 [05]ER27941 [07]ER40931 [09]ER46839 [11]ER52247 [13]ER58048 [15]ER65226 [17]ER71303

* weeks unemployed
*wksue<h/w>_eu = rowtotal(wksue<h/w>e wksue<h/w>u), miss
*wksue<h/w> = wksue<h/w>_eu if year >=1976 & year <= 1993

local wksueh [69]V672 [70]V1336 [71]V2042 [72]V2642 [73]V3159 [74]V3575 [75]V4030 [94]ER4101 [95]ER6941 [96]ER9192 [97]ER12179 [99]ER16476 [01]ER20404 [03]ER24086 [05]ER27892 [07]ER40882 [09]ER46778 [11]ER52186 [13]ER57987 [15]ER65167 [17]ER71244
local wksuew [94]ER4112 [95]ER6952 [96]ER9203 [97]ER12190 [99]ER16487 [01]ER20415 [03]ER24097 [05]ER27903 [07]ER40893 [09]ER46799 [11]ER52207 [13]ER58008 [15]ER65188 [17]ER71265

local wksuehe [76]V4505 [77]V5414 [78]V5903 [79]V6514 [80]V7117 [81]V7740 [82]V8402 [83]V9033 [84]V10558 [85]V11702 [86]V13102 [87]V14200 [88]V15254 [89]V16755 [90]V18193 [91]V19493 [92]V20793 [93]V22570
local wksuehu [76]V4568 [77]V5470 [78]V5997 [79]V6570 [80]V7172 [81]V7820 [82]V8481 [83]V9118 [84]V10626 [85]V11799 [86]V13195 [87]V14291 [88]V15401 [89]V16916 [90]V18340 [91]V19640 [92]V20940 [93]V22736
local wksuewe [76]V4888 [77]V5519 [78]V6050 [79]V6610 [80]V7212 [81]V7903 [82]V8561 [83]V9211 [84]V10772 [85]V12065 [86]V13279 [87]V14373 [88]V15556 [89]V17074 [90]V18495 [91]V19795 [92]V21095 [93]V22923
local wksuewu [76]V4952 [79]V6642 [80]V7244 [81]V7933 [82]V8588 [83]V9247 [84]V10826 [85]V12162 [86]V13363 [87]V14455 [88]V15703 [89]V17235 [90]V18642 [91]V19942 [92]V21242 [93]V23089

********************************************************************************
* real after tax family income (ftax and stax estimated using TAXSIM)
* famincrat  = (faminc -ftax -stax)/def
local faminc [68]V81 [69]V529 [70]V1514 [71]V2226 [72]V2852 [73]V3256 [74]V3676 [75]V4154 [76]V5029 [77]V5626 [78]V6173 [79]V6766 [80]V7412 [81]V8065 [82]V8689 [83]V9375 [84]V11022 [85]V12371 [86]V13623 [87]V14670 [88]V16144 [89]V17533 [90]V18875 [91]V20175 [92]V21481 [93]V23322 [94]ER4153 [95]ER6993 [96]ER9244 [97]ER12079 [99]ER16462 [01]ER20456 [03]ER24099 [05]ER28037 [07]ER41027 [09]ER46935 [11]ER52343 [13]ER58152 [15]ER65349 [17]ER71426

* State
local psidstatecode [68]V93 [69]V537 [70]V1103 [71]V1803 [72]V2403 [73]V3003 [74]V3403 [75]V3803 [76]V4303 [77]V5203 [78]V5703 [79]V6303 [80]V6903 [81]V7503 [82]V8203 [83]V8803 [84]V10003 [85]V11103 [86]V12503 [87]V13703 [88]V14803 [89]V16303 [90]V17703 [91]V19003 [92]V20303 [93]V21603 [94]ER4156 [95]ER6996 [96]ER9247 [97]ER12221 [99]ER13004 [01]ER17004 [03]ER21003 [05]ER25003 [07]ER36003 [09]ER42003 [11]ER47303 [13]ER53003 [15]ER60003 [17]ER66003

* family size
local famsize [68]V115 [69]V549 [70]V1238 [71]V1941 [72]V2541 [73]V3094 [74]V3507 [75]V3920 [76]V4435 [77]V5349 [78]V5849 [79]V6461 [80]V7066 [81]V7657 [82]V8351 [83]V8960 [84]V10418 [85]V11605 [86]V13010 [87]V14113 [88]V15129 [89]V16630 [90]V18048 [91]V19348 [92]V20650 [93]V22405 [94]ER2006 [95]ER5005 [96]ER7005 [97]ER10008 [99]ER13009 [01]ER17012 [03]ER21016 [05]ER25016 [07]ER36016 [09]ER42016 [11]ER47316 [13]ER53016 [15]ER60016 [17]ER66016

* marital status
local mstatus [68]V239 [69]V607 [70]V1365 [71]V2072 [72]V2670 [73]V3181 [74]V3598 [75]V4053 [76]V4603 [77]V5650 [78]V6197 [79]V6790 [80]V7435 [81]V8087 [82]V8711 [83]V9419 [84]V11065 [85]V12426 [86]V13665 [87]V14712 [88]V16187 [89]V17565 [90]V18916 [91]V20216 [92]V21522 [93]V23336 [94]ER4159A [95]ER6999A [96]ER9250A [97]ER12223A [99]ER16423 [01]ER20369 [03]ER24150 [05]ER28049 [07]ER41039 [09]ER46983 [11]ER52407 [13]ER58225 [15]ER65461 [17]ER71540

* moved
local moved [69]V603 [70]V1274 [71]V1979 [72]V2577 [73]V3110 [74]V3524 [75]V3941 [76]V4452 [77]V5366 [78]V5866 [79]V6484 [80]V7089 [81]V7700 [82]V8369 [83]V8999 [84]V10447 [85]V11628 [86]V13037 [87]V14140 [88]V15148 [89]V16649 [90]V18087 [91]V19387 [92]V20687 [93]V22441 [94]ER2062 [95]ER5061 [96]ER7155 [97]ER10072 [99]ER13077 [01]ER17088 [03]ER21117 [05]ER25098 [07]ER36103 [09]ER42132 [11]ER47440 [13]ER53140 [15]ER60155 [17]ER66156

** CONSUMPTION
* Food
* at home
local fhome1 [94]ER3078 [95]ER6077 [96]ER8174 [97]ER11068 [99]ER14288 [01]ER18421 [03]ER21686 [05]ER25688 [07]ER36706 [09]ER42712 [11]ER48028 [13]ER53725 [15]ER60740 [17]ER66787
local fhome1per [94]ER3079 [95]ER6078 [96]ER8175 [97]ER11069 [99]ER14289 [01]ER18422 [03]ER21687 [05]ER25689 [07]ER36707 [09]ER42713 [11]ER48029 [13]ER53726 [15]ER60741 [17]ER66788
local fhome2 [68]V37 [69]V500 [70]V1175 [71]V1876 [72]V2476 [74]V3441 [75]V3841 [76]V4354 [77]V5271 [78]V5770 [79]V6376 [80]V6972 [81]V7564 [82]V8256 [83]V8864 [84]V10235 [85]V11375 [86]V12774 [87]V13876 [90]V17807 [91]V19107 [92]V20407 [93]V21707 [94]ER3085 [95]ER6084 [96]ER8181 [97]ER11076 [99]ER14295 [01]ER18431 [03]ER21696 [05]ER25698 [07]ER36716 [09]ER42722 [11]ER48038 [13]ER53735 [15]ER60750 [17]ER66797
local fhome2per [94]ER3086 [95]ER6085 [96]ER8182 [97]ER11077 [99]ER14296 [01]ER18432 [03]ER21697 [05]ER25699 [07]ER36717 [09]ER42723 [11]ER48039 [13]ER53736 [15]ER60751 [17]ER66798

* delivered
local foodd1 [94]ER3081 [95]ER6080 [96]ER8177 [97]ER11071 [99]ER14291 [01]ER18425 [03]ER21690 [05]ER25692 [07]ER36710 [09]ER42716 [11]ER48032 [13]ER53729 [15]ER60744 [17]ER66791
local foodd1per [94]ER3082 [95]ER6081 [96]ER8178 [97]ER11072 [99]ER14292 [01]ER18426 [03]ER21691 [05]ER25693 [07]ER36711 [09]ER42717 [11]ER48033 [13]ER53730 [15]ER60745 [17]ER66792
local foodd2 [94]ER3088 [95]ER6087 [96]ER8184 [97]ER11079 [99]ER14298 [01]ER18435 [03]ER21700 [05]ER25702 [07]ER36720 [09]ER42726 [11]ER48042 [13]ER53739 [15]ER60754 [17]ER66801
local foodd2per [94]ER3089 [95]ER6088 [96]ER8185 [97]ER11080 [99]ER14299 [01]ER18436 [03]ER21701 [05]ER25703 [07]ER36721 [09]ER42727 [11]ER48043 [13]ER53740 [15]ER60755 [17]ER66802

* away from home
local fout1 [94]ER3083 [95]ER6082 [96]ER8179 [97]ER11073 [99]ER14293 [01]ER18428 [03]ER21693 [05]ER25695 [07]ER36713 [09]ER42719 [11]ER48035 [13]ER53732 [15]ER60747 [17]ER66794
local fout1per [94]ER3084 [95]ER6083 [96]ER8180 [97]ER11074 [99]ER14294 [01]ER18429 [03]ER21694 [05]ER25696 [07]ER36714 [09]ER42720 [11]ER48036 [13]ER53733 [15]ER60748 [17]ER66795
local fout2 [69]V506 [70]V1185 [71]V1886 [72]V2480 [74]V3445 [75]V3853 [76]V4368 [77]V5273 [78]V5772 [79]V6378 [80]V6974 [81]V7566 [82]V8258 [83]V8866 [84]V10237 [85]V11377 [86]V12776 [87]V13878 [90]V17809 [91]V19109 [92]V20409 [93]V21711 [94]ER3090 [95]ER6089 [96]ER8186 [97]ER11081 [99]ER14300 [01]ER18438 [03]ER21703 [05]ER25705 [07]ER36723 [09]ER42729 [11]ER48045 [13]ER53742 [15]ER60757 [17]ER66804
local fout2per [94]ER3091 [95]ER6090 [96]ER8187 [97]ER11082 [99]ER14301 [01]ER18439 [03]ER21704 [05]ER25706 [07]ER36724 [09]ER42730 [11]ER48046 [13]ER53743 [15]ER60758 [17]ER66805

* Alt Consumption (Table A.8)
local hfurn [05]ER25813 [07]ER36831 [09]ER42822 [11]ER48144 [13]ER53838 [15]ER60897 [17]ER66949
local hrec [05]ER25828 [07]ER36846 [09]ER42837 [11]ER48159 [13]ER53853 [15]ER60912 [17]ER66964
local vaca [05]ER25823 [07]ER36841 [09]ER42832 [11]ER48154 [13]ER53848 [15]ER60907 [17]ER66959
local school [99]ER13202 [01]ER17213 [03]ER21849 [05]ER25805 [07]ER36823 [09]ER42814 [11]ER48136 [13]ER53830 [15]ER60889 [17]ER66937
local cloth [05]ER25818 [07]ER36836 [09]ER42827 [11]ER48149 [13]ER53843 [15]ER60902 [17]ER66954
local clothper [05]ER25819 [07]ER36837 [09]ER42828 [11]ER48150 [13]ER53844 [15]ER60903 [17]ER66955

* Imputed nondurables consumption, bpp - see Readme_BPP

** WEALTH
* totalfw: rowtotal(w_ore w_farm w_stk w_cash w_bond -1*w_odebt w_vehic w_ira)

* w_ore (real estate)
local valore [84]V10899 [89]V17318 [94]ER3722 [99]ER14993 [01]ER19189 [03]ER22554 [05]ER26535 [07]ER37553 [09]ER43544 [11]ER48869
local valorepos [13]ER54612 [15]ER61723 [17]ER67776
local valoreneg [13]ER54616 [15]ER61727 [17]ER67780

* w_farm (business)
local valfarm [84]V10908 [89]V17323 [94]ER3731 [99]ER15002 [01]ER19198 [03]ER22563 [05]ER26544 [07]ER37562 [09]ER43553 [11]ER48878
local valfarmpos [13]ER54625 [15]ER61736 [17]ER67789
local valfarmneg [13]ER54629 [15]ER61740 [17]ER67793

* w_stk (stocks)
local w_stk [84]V10913 [89]V17326 [94]ER3736 [99]ER15007 [01]ER19203 [03]ER22568 [05]ER26549 [07]ER37567 [09]ER43558 [11]ER48883 [13]ER54634 [15]ER61745 [17]ER67798

* w_cash (transaction accounts/cash)
local w_cash [84]V10918 [89]V17329 [94]ER3742 [99]ER15020 [01]ER19216 [03]ER22596 [05]ER26577 [07]ER37595 [09]ER43586 [11]ER48911 [13]ER54661 [15]ER61772 [17]ER67826

* w_bond (bonds, 
local w_bond [84]V10923 [89]V17332 [94]ER3748 [99]ER15026 [01]ER19222 [03]ER22617 [05]ER26598 [07]ER37616 [09]ER43607 [11]ER48932 [13]ER54682 [15]ER61793 [17]ER67847

* w_odebt: amtodebt if year < 2011, rowtotal(amtodebtcard amtodebtstudloan amtodebtmedbill amtodebtlegalbill amtodebtrel amtodebtoth) if year >= 2011
local amtodebt [84]V10933 [89]V17335 [94]ER3753 [99]ER15031 [01]ER19227 [03]ER22622 [05]ER26603 [07]ER37621 [09]ER43612
local amtodebtcard [11]ER48937 [13]ER54687 [15]ER61798 [17]ER67852
local amtodebtstudloan [11]ER48945 [13]ER54697 [15]ER61808 [17]ER67862
local amtodebtmedbill [11]ER48949 [13]ER54702 [15]ER61813 [17]ER67867
local amtodebtlegalbill [11]ER48953 [13]ER54707 [15]ER61818 [17]ER67872
local amtodebtrel [11]ER48957 [13]ER54712 [15]ER61823 [17]ER67877
local amtodebtoth [13]ER54718 [15]ER61829 [17]ER67883

* w_vehic
local w_vehc [84]V10903 [89]V17320 [94]ER3726 [99]ER14997 [01]ER19193 [03]ER22558 [05]ER26539 [07]ER37557 [09]ER43548 [11]ER48873 [13]ER54620 [15]ER61731 [17]ER67784

* w_ira
local w_ira [99]ER15014 [01]ER19210 [03]ER22590 [05]ER26571 [07]ER37589 [09]ER43580 [11]ER48905 [13]ER54655 [15]ER61766 [17]ER67819

* l_liqw_combo = rowtotal(w_stk1 w_cash1 w_bond1)
*	w_stk1 = w_stk if w_stk >0
*	w_cash1 = w_cash if w_cash >0
*	w_bond1 = w_bond if w_bond >0

* hvalue
local hvalue [68]V5 [69]V449 [70]V1122 [71]V1823 [72]V2423 [73]V3021 [74]V3417 [75]V3817 [76]V4318 [77]V5217 [78]V5717 [79]V6319 [80]V6917 [81]V7517 [82]V8217 [83]V8817 [84]V10018 [85]V11125 [86]V12524 [87]V13724 [88]V14824 [89]V16324 [90]V17724 [91]V19024 [92]V20324 [93]V21610 [94]ER2033 [95]ER5032 [96]ER7032 [97]ER10036 [99]ER13041 [01]ER17044 [03]ER21043 [05]ER25029 [07]ER36029 [09]ER42030 [11]ER47330 [13]ER53030 [15]ER60031 [17]ER66031

* rpmort: rowtotal(rpmort1st rpmort2nd)
local rpmort1st [69]V451 [70]V1124 [71]V1825 [72]V2425 [76]V4320 [77]V5219 [78]V5719 [79]V6321 [80]V6919 [81]V7519 [83]V8819 [84]V10020 [85]V11127 [86]V12526 [87]V13726 [88]V14826 [89]V16326 [90]V17726 [91]V19026 [92]V20326 [93]V21612 [94]ER2037 [95]ER5036 [96]ER7042 [97]ER10044 [99]ER13047 [01]ER17052 [03]ER21051 [05]ER25042 [07]ER36042 [09]ER42043 [11]ER47348 [13]ER53048 [15]ER60049 [17]ER66051

local rpmort2nd [94]ER2038 [95]ER5037 [96]ER7043 [97]ER10045 [99]ER13056 [01]ER17063 [03]ER21062 [05]ER25053 [07]ER36054 [09]ER42062 [11]ER47369 [13]ER53069 [15]ER60070 [17]ER66072

* ltv = rpmort/hvalue
* hequity = hvalue - rpmort if rpmort !=. & hvalue !=.
